Microsoft Excel is full of logic based conditional functions.
We've taken a look at a few of them so far during this course.
The next one that we're going to take a look at is the count if function now instead of Excel we have
a standard count function and the standard count function will go through and count a range of cells
that contain numeric data.
We've also got a count Blancs function built into excel which will count blate cells from a range of
cells.
Now the one that we're going to take a look at here will count a range of cells based on a condition
that we specify we're essentially going to take a standard count function and combine it with an if
I want to count if something is true now open in front of you once again I've got an example file I'm
still on the function worksheet and I've got a cell here and this is cell F 14 where I'd like to count
the current number of sales people who have reached their goal.
What's the goal.
Well we decided that earlier right was the goal met.
We've got some yeses and nos and I just want to count the yeses.
That's it.
Think about this any time that you need to go through and list the records inside of Excel.
And I want to know how many records matched this criteria.
You've probably done this manually record by record by record.
There's one one there's another there's two there's three there's four.
Oh no there's not one there's back three yet.
There's a very manual process.
Now let's take a look at the count if function and how we can streamline our efforts in accounting records
based on a condition.
Take a look.
So I'm a set of 14.
I'm going to go back to my formulas tab back into logical and let's see.
Ooh you know I've got my logical kind of text or or conditional based functions inside of here but I
don't see my count.
Let's see where we can find this one at.
I'm going to hop into my insert function window this open on my insert function window and in here I
could do a quick little search.
I can go in a little drop down and pick from categories very similar to I found in my formulas bar.
Now my first thought is it should be logical because it's an F.
When I scroll through them once again I don't see it.
So I was going to do a quick little search here.
Well say count if I hit the go button it will go through and find everything related to this turn that
I searched on.
There's count and count and there's f and there's count.
If so then when selected.
OK then this opener my function arguments when no for the count if function.
So it wants to know two things.
It wants to know the range of cells and I'd like to count.
And it wants to know the criteria.
Very simple.
So first the range let me to go grab this range of cells here H five to eight nine.
That's right.
Want to count whether or not they met their goal and the criteria that I'm searching for.
I want to count all of the yeses so in quotes here.
I mean to type in yes.
And that's it all hit OK and probably no big surprise here.
But there's a three I'm counting a very specific value from this group of cells in this case counting
the yeses.
Try this out really simple count.
If it's specified the range of cells that you want to count within and the criteria what is it that
you're counted within that range of cells